Item Substitution for Unavailable Items Relating to a Customer Order

ABSTRACT

A technique is disclosed for automatically implementing item substitutions for unavailable items in a customer order. According to one embodiment, line item orders from selected customer orders may be aggregated and processed for substitution analysis. Substitutions for unavailable items of selected customer orders may then be automatically implemented based upon substitution instructions, business rules, and/or other predefined criteria.

CROSS-REFERENCE TO RELATED APPLICATIONS

This application is a continuation of U.S. patent application Ser. No. 11/818,010, filed Jun. 13, 2007, and entitled “Item Substitution for Unavailable Items Relating to a Customer Order,” which is incorporated herein by reference, and which is a continuation of U.S. patent application Ser. No. 09/750,385, filed Dec. 27, 2000, and entitled “Technique for Implementing Item Substitution for Unavailable Items Relating to a Customer Order,” which is incorporated herein by reference.

This application is related to the following patent applications: U.S. patent application Ser. No. 09/568,603 (now U.S. Pat. No. 7,177,825); U.S. patent application Ser. No. 09/568,570; and U.S. patent application Ser. No. 09/568,569 (now U.S. Pat. No. 6,622,127), all filed on May 10, 2000. Each of the above-referenced U.S. patent applications is incorporated herein by reference for all purposes.

BACKGROUND OF THE INVENTION

The present invention pertains to order substitution methods and systems that automatically perform substitutions for unavailable items in a customer order. More specifically, the invention allows for the substitution of unavailable items based upon predetermined criteria and set processes, so that the substitutions are made in a manner that optimizes efficiency and customer satisfaction.

Substitution methods in the current art typically use non-systematic and inefficient procedures in order to provide substitute items for unavailable items in a customer order. For example, some Internet-based grocery shoppers, (such as, for example, Peapod Inc., of Skokie, Ill.), send human buyers to one or more stores in order to fulfill customer orders. If a buyer is trying to fulfill an order for Brand A 64 oz. Ketchup, for example, and it is out of stock at the store, the buyer can make a substitution in order to approximate the product that the customer ordered. However, the substituted item may only be chosen from available items on the grocery shelf, which are typically adjacent to the unavailable items on the shelf space. Thus, for example, the buyer might substitute the same brand ketchup in a different size or variety, or a different brand in a similar size or variety, assuming that either is available at the store.

There are several problems with conventional order substitution methods. For one, the buyer's guess often does not result in a satisfactory substitute, particularly since they buyer is typically not an expert on all types of products. Also, the buyer does not have a procedure by which to consider all of his or her or her customer orders in the aggregate in order to make decisions that better maximize customer satisfaction. Further, no procedures exist for aggregating the orders of one buyer with that of other buyers in order to make larger aggregate decisions. Additionally, the buyer also does not have access to data concerning the available inventory of the store before attempting to fulfill his or her orders, and therefore is only able to make ad hoc decisions at the time of fulfillment.

For these, and other reasons, an efficient, automatic system architecture and method is desired to implement substitutions for unavailable items in customer orders.

SUMMARY OF THE INVENTION

This invention provides systems and methods for implementing item substitutions with respect to consumer orders in order to implement substitutions of unavailable items in customer orders. In a specific embodiment, this is accomplished by first taking customer orders via a data or computer network. A selected number of customer orders may then be aggregated and analyzed in order to make item substitution decisions. The decisions may be based upon a variety of different criteria, including one or more of the following: data from the selected customer orders, customer preferences, predefined substitution rules for each of the products, and accurate inventory information on the actual availability of products, etc.

Specific embodiments of the invention provide a method and computer program product for effecting, via a computer network, substitution of at least one ordered item of at least one customer order. At least one customer order is received via the computer network. At least a portion of the received customer order is analyzed to determine whether at least one item of inventory has been oversold. According to a specific implementation, the analyzed order data may be compared to available inventory data to determine whether at least one item of inventory has been oversold. Order line items relating to an identified oversold item may then be identified, wherein each order line item may be associated with a respective customer order. According to a specific implementation, order line items for identified oversold items may be selected using at least a portion of the predefined criteria. At least one second item may then be substituted for an identified oversold item in selected customer orders, based upon the predefined criteria. According to one implementation, the item substitution technique of the present invention may be performed by an automated computer process. It may also be performed at a time of fulfilling an order without intervention from a human operator.

According to a specific implementation, the predefined criteria may include a variety of business rules relating to how line items are selected for substitution analysis, and relating to how substitute items are selected. For example, the predefined criteria may include rules relating to minimizing a total number of order substitutions performed for each customer order; rules relating to selecting, for substitution analysis, order line items which have a relatively highest order quantity; sorted list of substitute products from which substitute items are chosen; rules for substituting a specific quantity of a second item for an unavailable item; etc.

An alternate embodiment of the present invention is directed to a system for effecting, via a computer network, substitution of at least one ordered item of at least one customer order. The system may include least one central processing unit, at least one interface configured or designed to receive at least one customer order via the computer network, and memory. The at least one customer order may include at least one order line item relating to an ordered quantity of a particular item of inventory. The memory may be configured to store customer order information and predefined criteria relating to item substitution rules. The system may be configured to analyze at least a portion of the received customer orders to determine whether at least one item of inventory has been oversold. The system may also be configured to identify order line items relating to an identified oversold item, wherein each order line item is associated with a respective customer order. The system may also be configured to substitute, based upon predefined criteria, at least one second item for the identified oversold item in selected customer orders.

Alternate embodiments of the present invention are directed to a method and computer program product for effecting, via a computer network, substitution of at least one ordered item of at least one customer order. At least one customer order is received via the computer network. Each customer order may include at least one order line item relating to an ordered quantity of a particular item of inventory. At least a portion of the received customer orders may then be analyzed to determine whether at least one item of inventory has been oversold. Order line items relating to an identified oversold item may be identified, each order line item being associated with a respective customer order. At least one second item may then be substituted for the identified oversold item in selected customer orders based upon predefined criteria.

Additional objects, features and advantages of the various aspects of the present invention will become apparent from the following description of its preferred embodiments, which description should be taken in conjunction with the accompanying drawings.

BRIEF DESCRIPTION OF THE DRAWINGS

FIG. 1 shows a schematic block diagram showing the most relevant parts of integrated system architecture in accordance with a specific embodiment of the present invention.

FIG. 2 shows a flow diagram of a Customer Order Handling Process in accordance with a specific embodiment of the present invention.

FIG. 3 shows a flow diagram of a Substitution Screening Procedure in accordance with a specific embodiment of the present invention.

FIG. 4 shows an example of substitution instructions for specified SKUs in accordance with a specific embodiment of the present invention.

FIG. 5 shows a flow diagram depicting an Item Substitution Procedure in accordance with a specific embodiment of the present invention.

FIG. 6 shows a flow diagram depicting a Partial Substitution Procedure in accordance with a specific embodiment of the present invention.

FIG. 7 shows a flow diagram depicting a Full Substitution Procedure in accordance with a specific embodiment of the present invention.

FIG. 8 is schematic illustration of hardware that is suitable for implementing the technique of the present invention.

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

The following discussion presents some terms and concepts pertinent to the operation of a distribution center. The invention is not specifically limited to the examples described hereafter.

FIG. 1 shows a schematic block diagram of a specific embodiment of an integrated system architecture 100 which may be used for implementing the automated substitution technique of the present invention. As shown in FIG. 1, system 100 includes a plurality of subsystems and other components for effecting electronic commerce over a data network. A brief description of at least a portion of the plurality of subsystems of system 100 is presented below.

For example, system 100 of FIG. 1 may include a Publishing (PUB) Subsystem 140 which provides an interface to merchants, vendors and/or content managers 133; a Webstore Subsystem (WS) 132 which manages the on-line store interface with customers, including customer shopping and ordering transactions; an Order Management Subsystem (OMS) 150 which manages pricing data, item availability data, inventory data, vendor data, finance, procurement, etc.; an Order Fulfillment Subsystem (OFS) 160 which facilitates the fulfillment of customer orders; etc. Each of the various subsystems shown in FIG. 1 of the drawings will now be described briefly below.

According to a specific implementation, the PUB Subsystem 140 may be used for managing SKU inventory and catalog information (e.g. SKUs, UPCs, products, categories, descriptive attributes, etc.), and item substitution information provided by merchants or vendors.

“Inventory” is the stock of SKU items actually available for customer orders. Each different item of inventory is associated with a respective stock keeping unit or SKU, regardless of whether the item is available for customer purchase. A “stock keeping unit” or SKU may be defined as a unique identifier that corresponds to a particular consumer item. A type of product, for example, Brand A ketchup, may have several unique SKUs, each corresponding, for example, to different sizes and/or flavors of Brand A ketchup.

Merchants and content managers 133 may enter and maintain SKU information stored in the PUB database using the PUB Web GUI interface 134 and PUB Bulk Loader interface 136. The SKU information may include SKU attribute values such as, for example, UPCs, vendors, categories, category hierarchy, images, articles, descriptive information, etc. The PUB Web GUI interface 134 allows merchants to edit SKU information, products, and/or categories. The PUB Bulk Loader 136 supports the processing of data files from outside the PUB Subsystem into the PUB database 141. According to a specific embodiment, the PUB Bulk Loader is configured to allow merchants to upload a variety of data file types into the PUB database including flat data files, and image files. The Bulk Loader processes the flat file information to create appropriate database records for the PUB catalog.

Periodically (e.g., minutes, hours, days) the OMS polls the PUB database for new and updated SKU information, and stores the retrieved data into the OMS database 151. According to a specific embodiment, OMS maintains available-to-promise (ATP), price, and inventory (e.g., replenishment and purchasing) information for each SKU. OMS may also capture and/or manage sales and shipment data relating to each SKU. Periodically, OMS passes new and updated SKU information it acquires from the PUB Subsystem to the OFS. The SKU information may be used by OFS, for example, to maintain physical inventory and fulfill orders.

According to a specific embodiment, the PUB Subsystem 140 may be used as an interface to allow merchants/vendors to enter substitution instructions relating to specific SKUs. An example of a set of substitution instructions for selected SKUs is shown in FIG. 4 of the drawings.

FIG. 4 shows an example of substitution instructions 400 for specified SKUs in accordance with a specific embodiment of the present invention. As shown in the example of FIG. 4, a set of “substitution instructions” may comprise a plurality of different fields, including, for example, a list of different SKUs 410, a description 411 of each SKU, and corresponding substitution rules 450 associated with each SKU. In the example of FIG. 4, substitution instructions are included for four SKU items, namely “Budweiser 6 pack” 402, “Wheaties 28 oz.” 404, “Lean Ground Beef” 406, and “Large Red Apples” 408.

As shown in the embodiment of FIG. 4, substitution rules 450 for each original SKU 410 may include one or more substitute SKUs 417. The substitution rules 450 may also include a ranking preference 412 for each substitute SKU, a substitution ratio 416 to be applied for each respective substitute SKU, a description 418 of each substitute SKU, pricing rules 420 for each substitute SKU, etc. For example the SKU entry 402 corresponding to “Budweiser 6 pack” may be substituted with three alternate SKU items, which have been sorted according to preference, namely, (1) Budweiser 12 pack, (2) Budweiser 2 liter, and (3) Miller 6 pack. The ranking indicates an order of preference, which means that the substitution procedure will attempt to use substitute SKU (1) first, then SKU (2) if SKU (1) is not available, then SKU (3) if neither SKU (1) or SKU (2) are available.

According to a specific implementation, the “substitution rules” for particular SKU indicate how substitutions are to be performed for that SKU. The substitute ratio field 416 may be used to determine how much quantity of a substitute SKU is to be substituted for a specified quantity of an original SKU. According to a specific embodiment, it is preferable to have a substitute ratio included since a substitution may not necessarily be one for one. The “charge rule” or pricing field 420 may be used to determine a price to bill the customer for the substituted item.

For example, if a customer orders a quantity of 1 “Budweiser 6 Pack”, and later it is determined that this SKU is oversold or unavailable, the substitution instructions 400 may be referenced in order to determine which products/items may be substituted for the unavailable item. According to the example of FIG. 4, a “Budweiser 12 pack” is the preferred choice for substituting for a “Budweiser 6 Pack.” Using the substitution rules shown in (402), a quantity of 0.50 “Budweiser 12 pack” may be substituted for each quantity of 1 “Budweiser 6 pack” item ordered, so that approximately the same amount of actual net weight beer is substituted. However, according to a specific implementation, substitute ratios may be rounded up to the nearest whole integer so that a customer that ordered one “Budweiser 6 pack” item will receive one “Budweiser 12 pack” item and not one-half of a “Budweiser 12 pack” item. If the customer had ordered two “Budweiser 6 pack” items, the customer may still receive only one “Budweiser 12 pack” item as a substitution.

Another aspect relating substitute item processing concerns pricing for substitute items. As shown in FIG. 4, the substitution instructions may include a “charge rule” or pricing field 420, which may be used to determine a price to bill the customer for the substituted item. For example, as shown in row 402 of FIG. 4, where one item of “Budweiser 12 pack” has been substituted for one item of “Budweiser 6 pack,” the pricing rule 420 specifies “lesser charge.” This means that the customer will be charged the lower of the two prices of either the original SKU or the substitute SKU. Thus, in this example, assuming that the price of a “Budweiser 6 pack.” item is less than the price of a “Budweiser 12 pack” item, the customer will be charged for the price of a “Budweiser 6 pack,” even if an entire “Budweiser 12 pack” item is substituted for the “Budweiser 6 pack.”

A different pricing rule is shown in FIG. 4 as “no charge.” This means that a customer will not be charged for a substituted item. For example, as shown in FIG. 4, if the “Miller 6 pack” item is substituted for a “Budweiser 6 pack” item, the customer incurs no charge for the substituted item. Presumably, this pricing may be used as appropriate to achieve desired levels of customer satisfaction.

According to a specific embodiment, the substitution instructions may also include a “not allowed” substitution rule for one or more SKUs. This is shown, for example, in entry 408 of FIG. 4. In this example, the original SKU item is “Large Red Applies”, and one of the substitute items listed is “Green Apples”, which is indicated by an “X” in the “rank” field 412, indicating that “Green Apples” are not allowed to be substituted for “Large Red Apples.” Thus, according to a specific implementation, while any item that is not listed in the substitution list is implicitly not allowed as a substitute SKU, an item may explicitly excluded as a possible substitute for one or more specified SKUs.

It will be appreciated that, in an alternate embodiment, the substitution instructions may be entered by merchants, vendors, or other human operators via the Webstore interface 132, or via other desired system interfaces. Further, according to a specific implementation, the merchant or vendor is able to add, rearrange, and remove items from the substitution list. Additionally, according to a specific embodiment, merchants and/or vendors may be provided with information relating to oversold items. For example, a merchant may be provided with information relating to selected oversold items for customer orders which are to be fulfilled the following day. The merchant is then able to analyze the oversold item information, and submit substitution instructions for the selected oversold items before the customer orders are fulfilled. According to one implementation, the oversold item information may be provided to a merchant via the PUB Subsystem 140.

According to at least one alternate embodiment, substitution instructions may be generated automatically using a general set of business and customer preference rules in order to save time and also optimize customer satisfaction. Preliminary substitution lists may also be generated in the same manner to be approved or edited by merchants. In any of these embodiments, the substitution instructions are typically stored in a database for retrieval at the appropriate point of use. In another embodiment, a substitution list can be dynamically generated at the time of use, again by using a general set of business and customer preference rules.

Webstore Subsystem (WS)

According to a specific implementation, the Webstore Subsystem (WS) 132 provides an interface for enabling customers to access an on-line store (e.g. Webstore), which, for example, may be used to provide a customer with an electronic representation of a retail store. In a specific embodiment where the Webstore may be implemented as a website on the World Wide Web, customers 102 may access the Webstore via the Internet 104 or World Wide Web using any one of a plurality of conventional browsers. The Webstore user interface may be designed to provide a rich set of functions without requiring any special browser plug-ins. Thus, according to a specific embodiment, customers may access the Webstore using any client machine, regardless of the machine's operating system platform. Additionally, for security purposes, the Webstore interface also supports data encryption for exchange of any sensitive or private information between the customers and the website. According to a specific embodiment, the secure Webstore interface may be implemented using a secure http protocol (HTTPS), commonly known to those of ordinary skill in the art.

In accordance with a specific embodiment, the Webstore Subsystem 132 may be configured to support a number of customer related features such as, for example, self registration; accessing of customer account information; browsing of product categories and category hierarchy; viewing of product images and product information; keyword searches; delivery scheduling; accessing of customer order history; customizable shopping lists; on-line shopping and ordering; etc.

The Webstore Subsystem (herein referred to as the Webstore) may be implemented using at least one server which is connected to the data network. According to a specific embodiment, the Webstore may be implemented using a plurality of web servers (e.g. a load-balanced web server farm) which helps to minimize server response time and provide real-time failover and redundancy capabilities. Further, according to a specific embodiment, in order to keep the web server response time to a minimum, the Webstore may be configured such that all processing is performed on a single server, within one process. Where a plurality of Webstore servers are used, redundant processing may be performed by at least a portion of the servers so that a single Webstore server may handle all Webstore processing tasks associated with a particular on-line customer. It will be appreciated that the Webstore server boundaries may be crossed where appropriate, such as, for example, when accessing desired databases via the data network.

Order Management Subsystem (OMS)

The Order Management Subsystem (OMS) 150 manages a variety of aspects related to the integrated system architecture of system 100, including, for example, pricing, availability, inventory, vendors, financials, procurement, and data flows between various subsystems.

As shown in FIG. 1, the OMS subsystem 150 includes at least one database 151 for storing various data received from at least a portion of the other subsystems. According to a specific embodiment, the database 151 is configured to include a plurality of schemas, such as, for example, standard packaged application schemas and/or customized schemas. According to a specific implementation, the OMS database is configured as a single Oracle database running on a Sun Solaris server.

According to a specific implementation, OMS batch processing may be controlled using a process scheduler. The process scheduler is able to manage the number of concurrent processes being run and the date/time at which certain processes are to run or be executed. The process scheduler may also enable central visibility of all processes currently running. Batch processing and reporting may be accomplished using a variety of different technologies commonly known to one having ordinary skill in the art.

The Order Management Subsystem may be configured to support both asynchronous and synchronous interfaces with the other subsystems. In a specific embodiment, the OMS is configured to support an asynchronous interface with each of the other subsystems. Additionally, each OMS interface is configurable, and may be configured to support the running of batch processes as often as is desirable.

Implementation of the various interfaces between OMS and the other subsystems may be accomplished using a variety of different techniques commonly known to one having ordinary skill in the art. The following description provides an example of at least some of the various techniques which may be used for interfacing OMS with the other subsystems. However, it will be appreciated that the specific interfaces described below may be implemented using other techniques commonly known to those of ordinary skill in the art.

The interface between the OMS and the Webstore Subsystem may be implemented, for example, using a plurality of executable programs. A first portion of the executable programs may be responsible for moving data from the Webstore to the OMS. This data may include, for example, new/updated customer data, new/updated order data, order cutoff information, order billing information, customer return information, customer credits and fees (e.g. bill adjustment data), etc. A second portion of the executable programs is responsible for moving data from the OMS to the Webstore Subsystem. This data may include, for example, inventory data, availability data, pricing data, and information about shipped customer orders.

Order Fulfillment Subsystem (OFS)

The Order Fulfillment Subsystem 160 manages all functionality of the distribution center (DC). In the embodiment of FIG. 1, the OFS includes appropriate hardware and/or software for managing the DC, including, for example, a warehouse management system (e.g. application software), at least one database 161, an automated material handling (AMH) controller component 163 (which manages conveyor, carousel, and scanner components), etc. In a specific implementation, the Order Fulfillment Subsystem 160 may be implemented using a warehouse management system such as, for example, the MOVE warehouse management system provided by Optum, Inc. of Costa Mesa, Calif. The warehouse system also provides an interface with the Order Management Subsystem. In a specific embodiment, this interface may be implemented using a business host interface (BHI). The warehouse management subsystem may also provide the interface for allowing the OMS subsystem to communicate with the OFS database 161.

The description is only a partial description of an architecture that is suitable for practicing the current invention, with emphasis on the subsystems that are most directly involved in the substitution procedure of the current invention. For a more complete description of such an architecture, see U.S. patent application Ser. No. 09/568,603 (Attorney Docket No. WVANP001).

It will be appreciated that other embodiments of the system of FIG. 1 may be used for implementing the technique of the present invention. For example, entire subsystems or selected features or components of the WS Subsystem 132, OMS Subsystem 150, PUB Subsystem 140, and/or OFS Subsystem 160 may be eliminated (if desired) or incorporated into other subsystems of the system of FIG. 1. Such modifications will be apparent to one having ordinary skill in the art. In a specific embodiment, it is preferable that the system 100 include at least a Webstore Subsystem (for receiving customer orders and maintaining inventory records), and an Order Fulfillment Subsystem (for fulfilling customer orders).

FIG. 2 shows a flow diagram of a Customer Order Handling Process 200 in accordance with a specific embodiment of the present invention. The Customer Order Handling Process of FIG. 2 depicts a simplified overview of the various processes by which customer orders are taken, the customer orders are processed (including substitutions), and the customer orders are fulfilled and delivered in accordance with a specific embodiment of the present invention.

At 202, a customer enters his or her customer order via the Webstore 132 interface (described above). According to a specific embodiment, a “customer order” includes a list of SKU items that have been ordered, their associated quantities, and other relevant information (e.g., payment information, delivery time information, etc.)

The customer order may include one or more “line item orders,” where each line item order corresponds to a particular SKU and includes a desired quantity of the ordered SKU. According to a specific embodiment, at the time of the customer order, the customer may also specify whether substitutions are allowed for the customer order generally, or alternatively, whether substitutions are allowed with respect to each specific line item order. The customer's general substitution preferences also may be stored in the Webstore database, and may be accessed and/or modified during the current customer order.

According to a specific embodiment, during the customer ordering process, customers will be provided information relating to availability of items. For example, customers may be provided with information relating to particular items which will not be available until after the customer's specified delivery date. In this way, item substitution of customer orders may be minimized.

However, for various reasons, it is possible that ordered items may be oversold or unavailable at the time of fulfillment of the order. For example, it is possible that the quantities of inventory levels for selected SKUs that are anticipated or expected to be available by a specific date are not actually available on that date. If it is not possible to fulfill a customer order because one or more ordered items are unavailable, that order may be said to be incomplete.

Incompletes may occur for a variety of reasons, such as, for example, vendor short shipments, goods found damaged at time of fulfillment, etc. For incompletes which relate to short shelf-life SKUs, such as, for example, bread and milk, it may be preferable, from a customer perspective, to substitute items, rather than to allow the order to be delivered incomplete.

Thus it will be appreciated that, substitution capability provides an opportunity to turn a problem into an improved customer experience. For example, customers may receive larger sizes at the smaller size price, may receive premium brands at non-premium brand prices, or may receive comparable brands at no charge.

Returning to FIG. 2, at a designated time after a customer order has been placed, a “cutoff” time occurs (204), at which point the customer is no longer able to modify the order. The customer order is then sent along with other “cutoff” customer orders to be processed (206). The processing of a customer order is generally described in U.S. patent application Ser. No. 09/568,603, previously incorporated herein by reference. According to a specific embodiment, the processing of a customer order includes performing item substitution analysis, which is generally described in FIGS. 3-7 of the drawings. In one implementation, order processing may be implemented at the Webstore Subsystem 132. In alternate embodiments, the order processing may be implemented at any desired subsystem which has been configured to handle the various tasks associated with the processing of customer orders. After the customer order has been processed, the customer order is then fulfilled (208) by obtaining the appropriate items from a warehouse, distribution center, or other locations. Once the order has been fulfilled, it may then be delivered (210) to the customer.

FIG. 3 shows a flow diagram depicting an Item Substitution Screening Procedure (300) in accordance with a specific embodiment of the present invention. According to one embodiment, the Item Substitution Screening Procedure may be initiated during the order processing operations described, for example, at 206 of FIG. 2. According to a specific implementation, as shown, for example, in FIG. 3, the Item Substitution Screening Procedure may be configured to analyze customer orders and to generate sorted line item orders of oversold items.

In the example of FIG. 3, it is assumed that order processing has been initiated for a batch of “cutoff” customer orders. As shown at 302 of FIG. 3, all or a selected portion of the cutoff customer orders are aggregated (302) so that they may be processed collectively by the Item Substitution Screening Procedure. The selected customer orders are then analyzed (304) to determine whether any of the SKUs relating to the customer orders (herein referred to as “original SKUs”) have been oversold. According to a specific embodiment, the quantity of oversold units for a particular SKU may be determined by comparing a total quantity of ordered units of that SKU (derived from the aggregated customer orders) to the quantity of available units of that SKU in the inventory. If the ordered quantity is greater than the available inventory quantity, it may be determined that the SKU has been oversold, wherein the “oversold quantity” may be represented as the difference between the ordered quantity and the available inventory quantity.

According to a specific embodiment, the quantity of available SKU units may be represented as a quantity of SKU units which are estimated to be available as of a specified date, such as, for example, the customer delivery date. According to a specific implementation, each of the customer orders in a given batch of cutoff customer orders will have the same delivery date.

Further, according to a specific embodiment, only SKUs that have associated “substitution instructions” will be analyzed for substitution analysis. As described previously, the system of the present invention may include a respective set of substitution instructions for each or selected SKUs in the inventory. These instructions may either be statically generated (e.g. created by a human operator) or dynamically generated (e.g. created by a computer system using predetermined business rules). An example of a set of substitution instructions for selected SKUs is shown in FIG. 4 of the drawings (described previously).

At 306, a determination is made as to whether there are any oversold SKUs identified. If at least one oversold SKU has been identified, then a first oversold SKU is selected (308) for substitution analysis. A determination is then made (309) as to whether substitutions are permitted for the selected oversold SKU. For example, if there are no substitution instructions for the selected oversold SKU, or if there are no substitute SKUs listed in the substitution instructions for the selected oversold SKU, then, according to at least one embodiment, substitutions are not permitted for the oversold SKU. Alternatively, the substitution instructions may specify that substitutions are not permitted for the oversold SKU. This may occur, for example, with respect to restricted SKU items such as alcohol or tobacco products.

If it is determined that substitutions are not permitted for the selected oversold SKU, then a next identified oversold SKU is selected (320) for substitution analysis. Assuming, however, that substitutions are permitted for the selected oversold SKU, line item orders (from the batch of cutoff customer orders) which correspond to the selected oversold SKU are then retrieved (310). According to a specific implementation, retrieved line item orders which correspond to customers who have requested not to received substitutions (either for the selected oversold SKU or generally) may be discarded (312) so that these line item orders are not considered for further substitution analysis. The remaining line item orders may then continue to be processed (314) for substitution analysis. The remaining line item orders may then be sorted (316) according to predefined criteria.

According to a specific embodiment, the predefined criteria may include business rules which define substitution preferences. Some of these business rules include the substitution instructions described previously with respect to FIG. 4. Other business rules may define substitution preferences based on other criteria, such as, for example: move line item orders that correspond to customer orders which already have at least one substituted item to the bottom of the list (thereby reducing the possibility of having multiple substitutions in a single customer order), substitute higher quantity line item orders first (thereby helping to reduce the total number of customer orders which include substituted items), and other rules designed to maximize customer satisfaction.

Additionally, according to a specific implementation, business rules may be included which prevent an oversold SKU and the substitute SKU from having different regulation codes (e.g. alcohol, tobacco, etc.). Additionally, business rules may be included which do not attempt to substitute a particular SKU for an oversold SKU if it is determined that the substitute SKU already exists as a line item in the customer order. Such business rules may be applied, for example, during substitute SKU selection as described, for example, with respect to FIG. 5 of the drawings.

Once the selected line item orders have been sorted, an Item Substitution Procedure (such as that shown, for example, in FIG. 5 of the drawings) may then be implemented (317) in order to perform the actual substitution for the selected oversold SKU. After the desired substitutions have been performed for the selected oversold SKU, a determination is then made (318) as to whether there are any additional oversold SKUs to be analyzed for substitution. If so, the Item Substitution Screening Procedure may then select (320) a next identified oversold SKU for substitution processing.

FIG. 5 shows a flow diagram depicting an Item Substitution Procedure 500 in accordance with a specific embodiment of the present invention. According to a specific embodiment, the Item Substitution Procedure (500) may be used to implement SKU substitutions for selected oversold SKUs.

Initially, as shown in the embodiment of FIG. 5, the Item Substitution Procedure may receive (502) one or more input parameters. In the example of FIG. 5, the input parameters include a sorted list of line item orders for a selected oversold SKU, which may be generated, for example, during the Item Substitution Screening Procedure of FIG. 3.

Assuming that the selected oversold SKU has been identified, the Item Substitution Procedure may then retrieve (504) the substitution instructions and other business rules (if any) relating to the identified oversold SKU. Alternatively, according to an alternate embodiment, the substitution instructions may be dynamically generated using predefined business rules specifically configured for generating substitution instructions or rules relating to specific SKUs or classes of SKUs.

As shown at 506 of FIG. 5, a first line item order from the line item list is selected (506) for item substitution analysis. The current oversold quantity for the identified oversold SKU is also retrieved (508). As described in greater detail below, the current quantity of the identified oversold SKU may periodically be updated during the Item Substitution Procedure as orders for the oversold SKU are replaced by substitute SKUs.

As shown at 508, the current oversold quantity is then compared (510) to the ordered quantity specified in the selected line item order. If it is determined that the ordered quantity is less than or equal to the current oversold quantity then a Full Substitution Procedure (such as that described, for example, in FIG. 6 of the drawings) may be implemented (511) for the selected line item order. If it is determined that the ordered quantity is greater than the current oversold quantity, then a Partial Substitution Procedure (such as that described, for example, in FIG. 7 of the drawings) may be implemented (512) for the selected line item order.

For example, if the current line item order specifies a quantity of 3 Large Red Apples, and the current oversold quantity of Large Red Apples is 4, then a full substitution procedure may be implemented, meaning that the full quantity of the line item order (e.g. 3) may be substituted. Once the substitution has been performed for the selected line item order, the current oversold quantity will be updated to 1 oversold large red apple. Alternatively, if the current line item order specifies a quantity of 3 Large Red Apples, and the current oversold quantity of Large Red Apples is 2, then a partial substitution procedure may be implemented, meaning that only a portion the line item order is to be substituted. In this example, the line item order may be filled by allocating 1 large red apple to the customer order, and substituting 2 Large Red Apples with other items.

After the appropriate substitution procedure has been be implemented for the selected line item order, a determination is then made (513) as to whether the substitution for the selected line item order was successful. If it is determined that the substitution was not successful, then, according to one embodiment, it may be assumed that no substitutions are available for the selected oversold product. Accordingly, the Item Substitution Procedure may end without attempting to perform any further substitutions for the selected oversold SKU.

Assuming, however, that the substitution for the selected line item order was successful, a determination is then made (514) as to whether the current oversold quantity for the identified oversold SKU is equal to zero. If it is determined that the current oversold quantity for the identified oversold SKU is equal to zero, then no further substitutions need be performed for the identified oversold SKU. If, however, the current oversold quantity for the identified oversold SKU is greater than zero, a determination may be made (516) as to whether there are additional line item orders (from the sorted list of line item orders) to be analyzed for item substitution analysis. If so, then a next line item order from the list is selected (506) for item substitution analysis.

FIG. 6 shows a flow diagram depicting a Partial Substitution Procedure 600 in accordance with a specific embodiment of the present invention. According to one embodiment, the Partial Substitution Procedure (600) may be implemented for a specified line item order in order to substitute a portion of the ordered quantity of the oversold SKU associated with that particular line item order.

Initially, as shown in the embodiment of FIG. 6, the Partial Substitution Procedure may receive (602) one or more input parameters. In the example of FIG. 6, the input parameters include a selected line item order for a selected oversold SKU, and an oversold quantity for the selected oversold SKU.

Once the selected oversold SKU has been identified, substitution instructions relating to the identified oversold SKU are retrieved (604) and processed in order to select (605) a first preferred substitute SKU for the identified oversold SKU. An example of substitution instructions is shown in FIG. 4 of the drawings.

At 606 a determination is made as to whether there is a sufficient available quantity of the selected substitute SKU to be substituted for the identified oversold SKU. If it is determined that there is an insufficient quantity of the selected substitute SKU available, then the substitution instructions may be consulted to determine (607) whether any alternate substitute SKUs are specified for the identified oversold SKU. Assuming that at least one alternate substitute SKU is specified, a next preferred substitute SKU is selected (605) for analysis. If it is determined that none of the substitute SKU(s) specified in the substitution instructions are available to be substituted for the identified oversold SKU, then, according to a specific implementation, the substitution may be reported (614) as being unsuccessful, and no substitution will be made for the identified oversold SKU.

Assuming that sufficient quantities of a selected substitute SKU are available to be substituted for the identified the oversold SKU quantity, then the partial substitution may be performed, for example, by adding (610) a “substitute line item order” to the customer order, specifying the substitute SKU and substituted quantity, and by reducing or modifying (612) the quantity in the selected line item of the customer order (corresponding to the identified oversold SKU) as appropriate. Additionally, the oversold quantity may be set (608) to zero, thereby indicating that the identified oversold SKU is no longer oversold.

For purposes of illustration, an example of the Partial Substitution Procedure will now be described using the substitution instructions illustrated in FIG. 4 of the drawings. In this example, it is assumed that the selected line item order specifies a quantity of 3 Large Red Apples, and that the current oversold quantity of Large Red Apples is equal to 2. Using the substitution list entry 408 of FIG. 4, a first preferred substitute item for “Large Red Apples” (SKU#4001) is “Medium Red Apples” (SKU#4003). Thus, the Partial Substitution Procedure will first check to see if there is a sufficient quantity of Medium Red Apples available to be substituted for the Large Red Apples. In this example, since the oversold quantity of Large Red Apples is equal to 2, only 2 of the 3 ordered Large Red Apples (of the customer's line item order) need be substituted. This may be referred to as a “partial substitution.” Additionally, as shown in FIG. 4, the substitute ratio of Medium Red Apples to Large Red Apples is 2:1, meaning that a total of four (4) Medium Red Apples will be required as a substitution for 2 Large Red Apples. Accordingly, the Partial Substitution Procedure checks to see whether 4 Medium Red Apples are available to be allocated.

If it is determined that 4 Medium Red Apples are available, a new line item specifying 4 Medium Red Apples will be added to the customer order (associated with the selected line item order). According to a specific embodiment, the new line item may be described as a partial substitution for the line item order of 3 Large Red Apples. Additionally, the quantity of the customer's (original) line item order for 3 Large Red Apples will be reduced to 1 Large Red Apples, and the quantity of oversold Large Red Apples will be reduced to zero.

Alternatively, if it is determined that no Medium Red Apples are available, a next preferred substitute SKU is selected (if available) for analysis. In the example of FIG. 4, the next preferred substitute item for Large Red Apples is Large McIntosh Apples (SKU#4007). Accordingly, the Partial Substitution Procedure will check to see whether 2 Large McIntosh Apples are available to be allocated to the identified customer order. If so, then the 2 Large McIntosh Apples will be substituted for 2 of the 3 Large Red Apples ordered in the identified customer order, thereby resulting in a partial substitution.

FIG. 7 shows a flow diagram depicting a Full Substitution Procedure 700 in accordance with a specific embodiment of the present invention. According to one embodiment, the Full Substitution Procedure (700) may be implemented for a specified line item order in order to substitute the ordered quantity of the oversold SKU associated with that particular line item order.

Initially, as shown in the embodiment of FIG. 7, the Full Substitution Procedure may receive (702) one or more input parameters. In the example of FIG. 7, the input parameters include a selected line item order for a selected oversold SKU, and an oversold quantity for the selected oversold SKU.

Once the selected oversold SKU has been identified, substitution instructions relating to the identified oversold SKU are retrieved (704) and processed in order to select (705) a first preferred substitute SKU for the identified oversold SKU. An example of substitution instructions is shown in FIG. 4 of the drawings.

At 706 a determination is made as to whether there is a sufficient available quantity of the selected substitute SKU to be substituted for the identified oversold SKU. If it is determined that there is an insufficient quantity of the selected substitute SKU available, then the substitution instructions may be consulted to determine (707) whether any alternate substitute SKUs are specified for the identified oversold SKU. Assuming that at least one alternate substitute SKU is specified, a next preferred substitute SKU is selected (705) for analysis. If it is determined that none of the substitute SKU(s) specified in the substitution instructions are available to be substituted for the identified oversold SKU, then, according to a specific implementation, the substitution may be reported (714) as being unsuccessful, and no substitution will be made for the identified oversold SKU.

Assuming that sufficient quantities of a selected substitute SKU are available to be substituted for the identified the oversold SKU quantity, then the full substitution may be performed, for example, by adding (710) a “substitute line item order” to the customer order, specifying the substitute SKU and substituted quantity, and by reducing or modifying (712) the quantity in the selected line item of the customer order (corresponding to the identified oversold SKU) to zero. In an alternate embodiment, the original line item order may be dropped from the customer order. Additionally, as shown in FIG. 7, the oversold quantity may be modified (708) or adjusted to reflect a new value which takes into account the number of oversold SKU items being substituted in the currently selected line item order.

For purposes of illustration, an example of the Full Substitution Procedure will now be described using the substitution instructions illustrated in FIG. 4 of the drawings. In this example, it is assumed that the selected line item order specifies a quantity of 3 Large Red Apples, and that the current oversold quantity of Large Red Apples is equal to 5. Using the substitution list entry 408 of FIG. 4, a first preferred substitute item for “Large Red Apples” (SKU#4001) is “Medium Red Apples” (SKU#4003). Thus, the Full Substitution Procedure will first check to see if there is a sufficient quantity of Medium Red Apples available to be substituted for the Large Red Apples. In this example, since the quantity of the selected line item order for Large Red Apples is equal to 3, a total of six (6) Medium Red Apples will be required as a substitution for 3 Large Red Apples. Accordingly, the Full Substitution Procedure checks to see whether 6 Medium Red Apples are available to be allocated.

If it is determined that 6 Medium Red Apples are available, a new line item specifying 6 Medium Red Apples will be added to the customer order (associated with the selected line item order). According to a specific embodiment, the new line item may be described as a full substitution for the line item order of 3 Large Red Apples. Additionally, the quantity of the customer's (original) line item order for 3 Large Red Apples will be reduced to zero Large Red Apples. Further the quantity of oversold Large Red Apples will be reduced by 3, making the new (or current) oversold quantity of Large Red Apples equal to 2.

The substitution technique of the present invention offers many advantages and capabilities over the conventional techniques. For example, technique of the present invention may be used to minimize the total number of substitutions to be implemented for a selected batch of customer orders by first implementing substitutions for line item orders of higher quantities. In addition, technique of the present invention may automatically prioritize line item orders so that customer orders that have already had at least one item substitution performed are less likely to have another item substitution performed. It will be appreciated that either of the above-described features may result in improved customer satisfaction.

Additionally, according to at least one embodiment of the present invention, substitution of ordered customer items may be automatically implemented without involving human decisions and/or human interactions at the time of fulfillment of the customer order(s). In this way, the technique of the present invention may be used to expedite order processing and order fulfillment, for example, by eliminating delays associated with human decisions and/or interactions.

Moreover, the technique of the present invention is highly scalable, and provides for more consistent and reliable substitutions as compared to conventional techniques. This, in turn, may result in improved overall quality control.

Other Embodiments

Generally, the item substitution technique of the present invention may be implemented on software and/or hardware. For example, it can be implemented in an operating system kernel, in a separate user process, in a library package bound into network applications, on a specially constructed machine, or on a network interface card. In a specific embodiment of this invention, the technique of the present invention is implemented in software such as an operating system or in an application running on an operating system.

A software or software/hardware hybrid implementation of the item substitution technique of this invention may be implemented on a general-purpose programmable machine selectively activated or reconfigured by a computer program stored in memory. Such programmable machine may be a network device designed to handle network traffic, such as, for example, a router or a switch. Such network devices may have multiple network interfaces including frame relay and ISDN interfaces, for example. A general architecture for some of these machines will appear from the description given below. In an alternative embodiment, the item substitution technique of this invention may be implemented on a general-purpose network host machine such as a personal computer or workstation. Further, the invention may be at least partially implemented on a card (e.g., an interface card) for a network device or a general-purpose computing device.

Referring now to FIG. 8, a network device 60 suitable for implementing the item substitution technique of the present invention includes a master central processing unit (CPU) 62, interfaces 68, and a bus 67 (e.g., a PCI bus). When acting under the control of appropriate software or firmware, the CPU 62 may be responsible for implementing specific functions associated with the functions of a desired network device. For example, when configured as a load balancing device, the CPU 62 may be responsible for analyzing packets, encapsulating packets, forwarding packets to appropriate network devices, performing content and/or format verification of data, etc. The CPU 62 preferably accomplishes all these functions under the control of software including an operating system (e.g. Windows NT), and any appropriate applications software.

CPU 62 may include one or more processors 63 such as a processor from the Motorola family of microprocessors or the MIPS family of microprocessors. In an alternative embodiment, processor 63 is specially designed hardware for controlling the operations of network device 60. In a specific embodiment, a memory 61 (such as non-volatile RAM and/or ROM) also forms part of CPU 62. However, there are many different ways in which memory could be coupled to the system. Memory block 61 may be used for a variety of purposes such as, for example, caching and/or storing data, programming instructions, etc.

The interfaces 68 are typically provided as interface cards (sometimes referred to as “line cards”). Generally, they control the sending and receiving of data packets over the network and sometimes support other peripherals used with the network device 60. Among the interfaces that may be provided are Ethernet interfaces, frame relay interfaces, cable interfaces, DSL interfaces, token ring interfaces, and the like. In addition, various very high-speed interfaces may be provided such as fast Ethernet interfaces, Gigabit Ethernet interfaces, ATM interfaces, HSSI interfaces, POS interfaces, FDDI interfaces and the like. Generally, these interfaces may include ports appropriate for communication with the appropriate media. In some cases, they may also include an independent processor and, in some instances, volatile RAM. The independent processors may control such communications intensive tasks as packet switching, media control and management. By providing separate processors for the communications intensive tasks, these interfaces allow the master microprocessor 62 to efficiently perform routing computations, network diagnostics, security functions, etc.

Although the system shown in FIG. 8 illustrates one specific network device of the present invention, it is by no means the only network device architecture on which the present invention can be implemented. For example, an architecture having a single processor that handles communications as well as routing computations, etc. is often used. Further, other types of interfaces and media could also be used with the network device.

Regardless of network device's configuration, it may employ one or more memories or memory modules (such as, for example, memory block 65) configured to store data, program instructions for the general-purpose network operations and/or other information relating to the functionality of the item substitution technique described herein. The program instructions may control the operation of an operating system and/or one or more applications, for example. The memory or memories may also be configured to include data structures which store customer order information, inventory data, item substitution instructions, substitution business rules, etc.

Because such information and program instructions may be employed to implement the systems/methods described herein, the present invention relates to machine readable media that include program instructions, state information, etc. for performing various operations described herein. Examples of machine-readable media include, but are not limited to, magnetic media such as hard disks, floppy disks, and magnetic tape; optical media such as CD-ROM disks; magneto-optical media such as floptical disks; and hardware devices that are specially configured to store and perform program instructions, such as read-only memory devices (ROM) and random access memory (RAM). The invention may also be embodied in a carrier wave traveling over an appropriate medium such as airwaves, optical lines, electric lines, etc. Examples of program instructions include both machine code, such as produced by a compiler, and files containing higher level code that may be executed by the computer using an interpreter.

Although certain preferred embodiments of this invention have been described in detail herein with reference to the accompanying drawings, it is to be understood that the invention is not limited to these precise embodiments, and at various changes and modifications may be effected therein by one skilled in the art without departing from the scope of spirit of the invention as defined in the appended claims. 

1. A computer-implemented method for effecting, via a computer network, substitution of at least one ordered item of at least one customer order at an online store, the method comprising: receiving, via the computer network, a plurality of customer orders placed by a plurality of customers; analyzing the plurality of customer orders to identify an item in the orders having been oversold, before delivering items in the orders to the plurality of customers; and substituting the oversold item with a substituted item for a customer order based on at least one substitution rule, wherein said substituting selects, from a plurality of customer orders that include the oversold item, at least one customer order that asks for the largest quantity of the oversold item so that the number of orders requiring substitution for the oversold item can be reduced.
 2. A computer-implemented method as recited in claim 1, wherein the at least one substitution rule is configured to minimize the number of items to be substituted for a customer order.
 3. A computer-implemented method as recited in claim 1, wherein the at least one substitution rule restricts substituting an item in a customer order if the customer so specifies when the customer places the customer order.
 4. A computer-implemented method as recited in claim 1, wherein the at least one substitution rule restricts substituting all items in a customer order if the customer so specifies when the customer places the customer order.
 5. A computer-implemented method as recited in claim 1, wherein the at least one substitution rule restricts substituting an oversold item if the oversold item is a regulated product.
 6. A computer-implemented method as recited in claim 1, wherein the at least one substitution rule restricts substituting an oversold item by a substituted item having a different regulation code.
 7. A computer-implemented method as recited in claim 1, wherein the at least one substitution restricts substituting an oversold item in a customer order by a substituted item if the customer order already includes the substituted item.
 8. A computer-implemented method as recited in claim 1, wherein the price of the oversold item is lower than the price of the substituted item, and wherein the customer paying for the customer order is charged the price of the oversold item, which is lower than the price of the substituted item.
 9. A computer-implemented method as recited in claim 1, wherein the size of the oversold item is smaller than the size of the substituted item.
 10. A computer-implemented method as recited in claim 1, wherein the oversold item is a non-premium brand, but the substituted item is a premium brand.
 11. A computer-implemented method as recited in claim 1, wherein the oversold item is identified to be substituted in view of its shelf-life being shorter than a plurality of other items that customers can order via the online store.
 12. A computer-implemented method as recited in claim 1, wherein the cost incurred by the customer for the substituted item is not greater than the cost otherwise would have been for the oversold item.
 13. A computer-implemented method as recited in claim 1, wherein of the quantity of oversold item ordered by a customer, a portion of them is substituted by the substituted item, and the remaining portion is filled by the oversold item.
 14. A computer-implemented method as recited in claim 1, further comprising allowing a merchant to enter information regarding at least one item via a publishing system, wherein at least one customer of the online store is allowed to access the information from the online store regarding the at least one item, wherein the at least one item from the merchant has become an oversold item, and wherein the online store notifies the merchant that the at least one item from the merchant has become an oversold item.
 15. A computer-implemented method as recited in claim 14, wherein the online store allows the merchant to provide a solution regarding the at least one item becoming an oversold item before the online store fulfills a customer order asking for the at least one item.
 16. A computer-implemented method as recited in claim 15, wherein the merchant determines an item to substitute for the at least one item, which the online store follows.
 17. A computer-implemented method as recited in claim 1, wherein a plurality of optional substituted items are identified to be the substituted item, and wherein the plurality of optional substituted items are ranked for substitution.
 18. A computer-implemented method for effecting, via a computer network, substitution of at least one ordered item of at least one customer order at an online store, the method comprising: receiving, via the computer network, a plurality of customer orders placed by a plurality of customers; analyzing the plurality of customer orders to identify an item in the orders having been oversold, before delivering items in the orders to the plurality of customers; and substituting the oversold item with a substituted item for a customer order based on at least one substitution rule, wherein the at least one substitution rule is configured to minimize the number of items to be substituted for a customer order.
 19. A computer-implemented method for effecting, via a computer network, substitution of at least one ordered item of at least one customer order at an online store, the method comprising: receiving, via the computer network, a customer order placed by a customer; analyzing the customer order with at least one other customer order to identify an item in the customer orders having been oversold, before delivering items in the orders to the customers; notifying the merchant that provides the oversold item to the online store that the item has become oversold; and allowing the merchant to provide a solution regarding the item becoming an oversold item before the online store fulfills a customer order asking for the item.
 20. A computer-implemented method as recited in claim 19, wherein the merchant determines an item to substitute for the oversold item, which the online store follows.
 21. A computer-implemented method for effecting, via a computer network, substitution of at least one ordered item of at least one customer order at an online store, the method comprising: receiving, via the computer network, a plurality of customer orders placed by a plurality of customers; analyzing the plurality of customer orders to identify an item in the orders having been oversold, before delivering items in the orders to the plurality of customers; and substituting the oversold item with a substituted item for a customer order based on at least one substitution rule, wherein the method further comprises determining whether to upgrade the oversold item based on size and/or brand. 